2a4f67ae9cb56e9132956bc0fffecdc6779677ea,ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog170.java,UpgradeCatalog170,executeDDLUpdates,#,164

Before Change



    dbAccessor.alterColumn("clusterconfig", new DBColumnInfo("config_data", char[].class, null, null, false));
    dbAccessor.alterColumn("blueprint_configuration", new DBColumnInfo("config_data", char[].class, null, null, false));
    dbAccessor.alterColumn("hostgroup_configuration", new DBColumnInfo("config_data", char[].class, null, null, false));

    columns.clear();
    columns.add(new DBColumnInfo("service_config_id", Long.class, null, null, false));

After Change


    dbAccessor.executeQuery("ALTER TABLE clusterconfig ADD CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag)", true);
    dbAccessor.executeQuery("ALTER TABLE clusterconfig ADD CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version)", true);

    if (!Configuration.ORACLE_DB_NAME.equals(dbType)) {
      dbAccessor.alterColumn("clusterconfig", new DBColumnInfo("config_data", char[].class, null, null, false));
      dbAccessor.alterColumn("blueprint_configuration", new DBColumnInfo("config_data", char[].class, null, null, false));
      dbAccessor.alterColumn("hostgroup_configuration", new DBColumnInfo("config_data", char[].class, null, null, false));
    }

    columns.clear();